gen covhoriperc1 = (100/11) * cov_pen_sum1
gen covvertiperc1 = (100/(cov_pen_sum1 * 5)) * cov_pen_sum2
  
 gen covindex = (covhoriperc1/100) * covvertiperc1
 
 gen cov_spawperc = (100/9) * cov_spaw
 
 gen cov_spawnperc = (100/9) * cov_spaw_new // this variable refers to the updated introduction dates
 
 tab year_pen year_spaw_intro

*** // Dropping refers to comparison PENLEG vs. new SPAW dataset (only introduction dates)
preserve

drop if country_name == "Honduras"
drop if country_name == "El Salvador"
drop if country_name == "Brazil"
drop if country_name == "Argentina"
drop if country_name == "Poland"
drop if country_name == "Italy"
drop if country_name == "Greece"
drop if country_name == "USSR (Russia)"
drop if country_name == "Latvia"
drop if country_name == "Equatorial Guinea"
drop if country_name == "Central African Republic"
drop if country_name == "Swaziland"
drop if country_name == "Madagascar"
drop if country_name == "Nepal"
drop if country_name == "Vietnam"

*** dropping those countries for which only one dataset had information for ***

drop if country_name == "Canada"
drop if country_name == "Colombia"
drop if country_name == "United Kingdom"
drop if country_name == "France"
drop if country_name == "Portugal"
drop if country_name == "Denmark"
drop if country_name == "Guinea"
drop if country_name == "Sierra Leone"
drop if country_name == "Mozambique"
drop if country_name == "South Africa"
drop if country_name == "Lesotho"
drop if country_name == "Iran"
drop if country_name == "Saudi Arabia"
drop if country_name == "Yemen"
drop if country_name == "Oman"
drop if country_name == "Bangladesh"
drop if country_name == "Laos"
drop if country_name == "East Timor"
drop if country_name == "Australia"
drop if country_name == "Papua New Guinea"
drop if country_name == "Tonga"
drop if country_name == "Liechtenstein"
drop if country_name == "San Marino"
drop if country_name == "Sao Tom� and Principe"
drop if country_name == "Tuvalu"
drop if country_name == "Maldives"
drop if country_name == "Monaco"
drop if country_name == "Samoa"

sum covindex
sum cov_spawnperc

